exports.path = '/example/selectInPlsql';
exports.title = '多次返回cursor范例';
exports.pool = 'task';

exports.sqltext = `
begin
  open :cur for
  select *
  from tf_mbss_tasks
  where rownum<3;

  open :dual for
  select *
  from dual;
end;
`;

exports.bindObj = {
  cur: {
    dir: oracledb.BIND_OUT,
    type: oracledb.CURSOR,
  },
  dual: {
    dir: oracledb.BIND_OUT,
    type: oracledb.CURSOR,
  },
};

exports.request = {};

exports.outConverter = sqlresult => sqlresult.outBinds;
